package com.order.itemcategoryproject.pojo;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import lombok.Getter;
import lombok.Setter;

import java.math.BigDecimal;
import java.sql.Timestamp;

@Getter
@Setter
@Data
public class dBlOrderDtOnline {


    // 商品编号
    @ExcelProperty(value = "商品编号", index = 1)
    private String itemId;
    // 订单号
    @ExcelProperty(value = "订单编号", index = 0)
    private String orderId;


    // 商品条码 69码
    @ExcelProperty(value = "商品条码", index = 2)
    private String barcode;

    @ExcelProperty(value = "商品品类名称", index = 3)
    private String itemCaClassName;

    @ExcelProperty(value = "商品大类名称", index = 4)
    private String itemBgClassName;

    @ExcelProperty(value = "商品中类名称", index = 5)
    private String itemMdClassName;
    // 商品小类名称
    @ExcelProperty(value = "商品小类名称", index = 6)
    private String itemSmClassName;

    // 商品小类编号
    @ExcelProperty(value = "商品小类编号", index = 7)
    private String itemSmClassId;
    // 商品名称
    @ExcelProperty(value = "商品名称", index = 8)
    private String itemName;
    // 商品价格
    @ExcelProperty(value = "采购价", index = 9)
    private double itemPrice;
    // 商品订购数量
    @ExcelProperty(value = "订购数量", index = 10)
    private int itemOrderNum;

    @JsonFormat(locale="zh", timezone="GMT+8", pattern="yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(value = "yyyy-MM-dd HH:mm:ss")
    @ExcelProperty(value = "添加订单时间", index = 13)
    private Timestamp uptime;
    // 制单人（创建人）
    @ExcelProperty(value = "下单人/客户", index = 14)
    private String createStaffId;
    @ExcelProperty(value = "备注", index = 15)
    private String remark;
    @ExcelProperty(value = "是否导入", index = 16)
    private String isImport;
    // 取消标记.
    @ExcelIgnore
    private String cancelSign;
    // 单品体积
    @ExcelProperty(value = "单品体积(m³)", index = 12)
    private double itemVolume;
    // 单品重量
    @ExcelIgnore
    private double itemWeight;

    // 商品分组后小类全部数量
    @ExcelIgnore
    private int totalNum;

    // 商品分组后小类求和金额
    @ExcelIgnore
    private BigDecimal totalPrice;

    // 单品总价格(单品价格 * 单品数量)
    @ExcelProperty(value = "总价格", index = 11)
    private double singleTotalPrice;

    @ExcelIgnore
    private String itemImgUrl;

    @ExcelProperty(value = "图片位置", index = 17)
    private String position;

    @ExcelProperty(value = "图片路径", index = 18)
    private String itemImgOnlineUrl;

    // 即将入库货品定量
    @ExcelProperty(value = "即将入库货品定量", index = 19)
    private int jjrkhpdl;

}
